<?xml version = '1.0' encoding = 'UTF-8'?>
<HBRRepo><variables><variable name="Currency" type="member" usage="const" id="1" product="Planning"><property name="application">BYOCOA</property><property name="dimension">Currency</property><property name="dimensionInputMode">name</property><property name="display_label">Currency</property><property name="prompt_text">Currency</property><property name="scope">87654321</property><property name="seeded">true</property><value/></variable><variable name="Entity" type="member" usage="const" id="2" product="Planning"><property name="application">BYOCOA</property><property name="dimension">Entity</property><property name="dimensionInputMode">name</property><property name="display_label">Entity</property><property name="prompt_text">LABEL_ENTITY</property><property name="scope">87654321</property><property name="seeded">true</property><value/></variable><variable name="Years" type="members" usage="const" id="3" product="Planning"><property name="application">BYOCOA</property><property name="dimensionType">Year</property><property name="display_label">Years</property><property name="prompt_text">ID_PRMTEXT_ENTER_THE_YEARS_07</property><property name="seeded">true</property><property name="useLastValue">false</property><value/><limits type="expression"><property name="value">@DESCENDANTS("Years")</property></limits></variable><variable name="ActualMonths" type="members" usage="const" id="4" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="dimension">Period</property><property name="dimensionInputMode">name</property><property name="display_label">ActualMonths</property><property name="prompt_text">Actual Months</property><property name="scope">87654321</property><property name="seeded">true</property><value/></variable></variables><rulesets/><rules><rule id="1" name="OFS_Prepare Forecast" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">OFS_Prepare Forecast</property><property name="seeded">true</property><variable_references><variable_reference name="Entity" id="2"><property name="application">BYOCOA</property><property name="hidden">false</property><property name="rule_name">OFS_Prepare Forecast</property><property name="seq">1</property><property name="type">3</property><property name="useAsOverrideValue">false</property><property name="validation_value">"OEP_No Entity"</property></variable_reference><variable_reference name="ActualMonths" id="4"><property name="application">BYOCOA</property><property name="hidden">false</property><property name="plantype">OEP_FS</property><property name="rule_name">OFS_Prepare Forecast</property><property name="seq">2</property><property name="type">4</property><property name="useAsOverrideValue">false</property><property name="validation_value">&amp;OEP_CurMnth</property></variable_reference><variable_reference name="Currency" id="1"><property name="application">BYOCOA</property><property name="hidden">false</property><property name="rule_name">OFS_Prepare Forecast</property><property name="seq">3</property><property name="type">3</property><property name="useAsOverrideValue">false</property><property name="validation_value">"No Currency"</property></variable_reference><variable_reference name="Years" id="3"><property name="application">BYOCOA</property><property name="hidden">false</property><property name="rule_name">OFS_Prepare Forecast</property><property name="seq">4</property><property name="type">4</property><property name="useAsOverrideValue">false</property><property name="validation_value">&amp;OEP_CurYr</property></variable_reference></variable_references><statement seq="1" type="component" kind="script" name=""><component type="script" id="-100" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">set updatecalc off;
set aggmis</property><script type="calcscript">set updatecalc off;
set aggmissg on;</script></component></statement><statement seq="2" id="-101" type="template" name="OFS_PREPAREFORECAST_T"><template_ref name="OFS_PrepareForecast_T" id="1" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">OFS_PrepareForecast_T</property><property name="image">TEMPLATE</property><property name="Tile_Key">x2y0</property><template_prompts><restricted_prompt name="Application Type" type="Application Type" isPrompt="false"><value>Is Generic</value></restricted_prompt><restricted_prompt name="Application" type="Application" isPrompt="false"><value>Is Simple Currency</value></restricted_prompt><template_slice_prompt name="UpperPOV" type="Member Range" isPrompt="false"/><template_prompt name="Rev Source Flex1" type="String" isPrompt="false"/><template_prompt name="Rev Source Flex2" type="String" isPrompt="false"/><template_prompt name="Rev Driver Flex1" type="String" isPrompt="false"/><template_prompt name="Rev Driver Flex2" type="String" isPrompt="false"/><template_prompt name="Rev Driver Flex3" type="String" isPrompt="false"/><template_prompt name="Rev Driver Flex4" type="String" isPrompt="false"/><template_prompt name="RevSrc1_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_Agg" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Agg" type="String" isPrompt="false"/><template_prompt name="mPeriod" type="Members" isPrompt="true"/><template_prompt name="mYear" type="Members" isPrompt="true"/><template_prompt name="mVersion" type="Member" isPrompt="true"/><template_prompt name="strEndFix" type="String" isPrompt="false"><value>EndFix</value></template_prompt><template_prompt name="dCurrency" type="Dimension" isPrompt="false"><value>Currency</value></template_prompt><template_prompt name="strCurrencyFix" type="String" isPrompt="false"/><restricted_prompt name="Essbase Mode" type="Essbase Mode" isPrompt="false"><value>Is Hybrid</value></restricted_prompt></template_prompts></template_ref></statement></rule></rules><components/><deployobjects><deployobject product="2" application="byocoa" plantype="oep_fs" obj_id="1" obj_type="1" name="OFS_PREPARE FORECAST"/></deployobjects><templates><template custom="yes" id="1" name="OFS_PrepareForecast_T" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">OFS_PrepareForecast_T</property><property name="seeded">true</property><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-100" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Rev Source Flex1 = @PLANDI...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>Rev Source Flex1</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Product")</user_inp></expression></formula><formula><destination><user_inp>Rev Source Flex2</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Services")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex1</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Cost Center")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex2</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Channel")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex3</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "Funding Segment")</user_inp></expression></formula><formula><destination><user_inp>Rev Driver Flex4</user_inp></destination><expression><user_inp>@PLANDIM(OEP_FS, "RevenueDriver4")</user_inp></expression></formula></conditionblock></formulae></component></statement><statement seq="2" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Currency eq Is Not Empty</property><property name="display_width">3</property><property name="Tile_Key">x2y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Application</user_inp></expression><expression seq="2"><user_inp>Is Simple Currency</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-102" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">strCurrencyFix = ,@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>strCurrencyFix</user_inp></destination><expression><user_inp>,@relative({Currency},0)</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="3" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Source Flex1 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x5y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Source Flex1</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-104" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevSrc1_Fix = Fix(@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevSrc1_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Product",0))</user_inp></expression></formula><formula><destination><user_inp>RevSrc1_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevSrc1_Agg</user_inp></destination><expression><user_inp>Agg("Product");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="4" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Source Flex2 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x8y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Source Flex2</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-106" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevSrc2_Fix = Fix(@relativ...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevSrc2_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Services",0))</user_inp></expression></formula><formula><destination><user_inp>RevSrc2_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevSrc2_Agg</user_inp></destination><expression><user_inp>Agg("Services");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="5" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex1 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x11y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex1</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-108" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver1_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver1_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Cost Center",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver1_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver1_Agg</user_inp></destination><expression><user_inp>Agg("Cost Center");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="6" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex2 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x14y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex2</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-110" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver2_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver2_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Channel",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver2_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver2_Agg</user_inp></destination><expression><user_inp>Agg("Channel");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="7" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex3 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x17y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex3</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-112" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver3_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver3_Fix</user_inp></destination><expression><user_inp>Fix(@relative("Funding Segment",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver3_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver3_Agg</user_inp></destination><expression><user_inp>Agg("Funding Segment");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="8" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">Rev Driver Flex4 eq Is Not...</property><property name="display_width">3</property><property name="Tile_Key">x20y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>Rev Driver Flex4</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-114" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">RevDriver4_Fix = Fix(@rela...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>RevDriver4_Fix</user_inp></destination><expression><user_inp>Fix(@relative("RevenueDriver4",0))</user_inp></expression></formula><formula><destination><user_inp>RevDriver4_EndFix</user_inp></destination><expression><user_inp>[strEndFix]</user_inp></expression></formula><formula><destination><user_inp>RevDriver4_Agg</user_inp></destination><expression><user_inp>Agg("RevenueDriver4");</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="9" type="component" kind="script" name=""><component type="script" id="-115" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="caption">Set Fix and clear</property><property name="display_label">Set Fix and clear</property><script type="calcscript">Fix(@relative({Entity},0) [strCurrencyFix])

Fix("OEP_Prior FCST",OEP_Forecast)								
      clearblock all;							
endfix
[RevSrc1_Fix]
[RevSrc2_Fix]
[RevDriver1_Fix]
[RevDriver2_Fix]
[RevDriver3_Fix]
[RevDriver4_Fix]

	
					
Fix(@remove(@relative("Account",0),@list(@relative("System Members",0),@relative("OFS_Cross Module Integration",0))))				
Fix(OEP_Forecast)
      Fix(@relative("OFS_Total Plan",0),{Years})								
              Fix(@remove(@relative("Period",0),@list(@relative("Financial Integration Mapping",0),"No Period")))							
                  DATACOPY "OEP_Working" TO "OEP_Prior FCST";						
              endfix						
      endfix							
endfix
										
	Fix(&amp;OEP_CurYr,OEP_Working)								
		fix({ActualMonths})							
			Fix(@relative("OFS_Total Plan",0))
                    cleardata "OEP_Forecast";
            endfix
			DATACOPY "OEP_Actual"->"OFS_Load" TO "OEP_Forecast"->"OFS_Calculated";						
		endfix					
	endfix					
endfix	

    										
 /* this section is required to calculate the drivers and then the none driver related accounts*/   	
Fix(OEP_Forecast)
	 Fix(OEP_Working)									
		Fix ({Years},@remove(@relative("Period",0),@list(@relative("Financial Integration Mapping",0),"No Period"))) 
        								
			Fix(@remove(@relative("Account",0),@list(@relative("System Members",0),@relative("OFS_Cross Module Integration",0))))		
				OFS_Calculated(
					@calcmode(block);	
                    @calcmode(bottomup);
							
                    if((@ismbr(&amp;OEP_FCSTStartYr) and @ismbr(&amp;OEP_FcstMnth:&amp;OEP_EndMnth)) or (@ismbr(@RSIBLINGS (&amp;OEP_CurYr)) and @ismbr(@relative("YearTotal",0))))				
	 					if(Not(@ismbr("No Year")))
	 					if("OFS_Trend"->"BegBalance" &lt;>#Missing)			 								
	        						%Script(name:="Monthly_Trends")             			
	        						%Script(name:="Forecast_Only_Trends")			   									
	    				endif	
						endif
					endif					</script></component></statement><statement seq="10" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_width">3</property><property name="Tile_Key">x21y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>@DIMMEMBER(Period, OEP_W53)</user_inp></expression><expression seq="2"><user_inp>Is Not Empty</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="formula" name=""><component type="formula" id="-117" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>WKScript</user_inp></destination><expression><user_inp>(@ismbr(@remove(@relative("OEP_Weekly Plan", 0),"OEP_W53"))) or ("TP-Weeks" == 53 and @ismbr(@relative("OEP_Weekly Plan", 0)))</user_inp></expression></formula></conditionblock></formulae></component></statement></then></if></statement><statement seq="11" type="component" kind="formula" name=""><component type="formula" id="-118" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Weekly = @DIMMEMBER("Perio...</property><property name="dtp_assignment">true</property><formulae><conditionblock><formula><destination><user_inp>Weekly</user_inp></destination><expression><user_inp>@DIMMEMBER("Period", "OEP_Weekly Plan")</user_inp></expression></formula><formula><destination><user_inp>IsWeeklyEnabled</user_inp></destination><expression><user_inp>@COMPARE([Weekly], "OEP_Weekly Plan", "true")</user_inp></expression></formula></conditionblock></formulae></component></statement><statement seq="12" type="if"><if product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_height">2</property><property name="display_label">IF</property><property name="display_width">3</property><property name="Tile_Key">x25y0</property><property name="use_dtp">true</property><test><expression><biop type="eq"><expression seq="1"><user_inp>IsWeeklyEnabled</user_inp></expression><expression seq="2"><user_inp>True</user_inp></expression></biop></expression></test><then><statement seq="1" type="component" kind="script" name=""><component type="script" id="-120" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="caption">Weekly Trends</property><property name="display_label">Weekly Trends</property><script type="calcscript">elseif(@ismbr(&amp;OEP_WeeklyFCSTRange))	
	If(Not(@ismbr("No Year")))	
    	if([WKScript])
		if((Not(@ismbr(&amp;OEP_CurYr) and @ismbr(OEP_W1:&amp;OEP_CurWeek))))
			%Script(name:="Weekly_Trends")									
			%Script(name:="Weekly_ForecastOnly")											
			endif         
        endif    				
		endif					
elseif (@ismbr(&amp;OEP_QrtlyFcstStart:&amp;OEP_QrtlyFcstEnd))						
	if(Not(@ismbr("No Year")))					
		if (@ismbr(@relative("OEP_Qrtly Plan", 0)))				
		If (@ismbr(&amp;OEP_CurYr) and @ismbr(@LSIBLINGS(&amp;OEP_CurQtr))) 
                    "OFS_Calculated" = @member(@HspNthMbr(@name(@children("YearTotal")), @HspMbrIndex(@name(@children("OEP_Qrtly Plan")), @name(@currmbr(Period)))));                                	
		else
			%Script(name:="Qrtly_Trends")		
		endif					
		endif				
	endif					
elseif (@ismbr(&amp;OEP_YrlyFcstStart:&amp;OEP_YrlyFcstEnd)) 						
	if(Not(@ismbr("No Year")))					
		if (@ismbr("OEP_Yearly Plan"))				
		%Script(name:="Yearly_Trends")				
		endif				
	endif					
endif						

endif						
 )						
 ;						
						
endfix							
	Fix(OFS_Calculated)							
		calc dim("Account");						
	endfix							
endfix									
endfix										
endfix

[RevDriver4_EndFix]
[RevDriver3_EndFix]
[RevDriver2_EndFix]
[RevDriver1_EndFix]
[RevSrc2_EndFix]
[RevSrc1_EndFix]

Endfix 			</script></component></statement></then><else><statement seq="1" type="component" kind="script" name=""><component type="script" id="-121" name="" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="caption">End of Calculation</property><property name="display_label">End of Calculation</property><script type="calcscript">							elseif (@ismbr(&amp;OEP_QrtlyFcstStart:&amp;OEP_QrtlyFcstEnd)) 					
							if(Not(@ismbr("No Year")))
                            if (@ismbr(@relative("OEP_Qrtly Plan", 0))) 			
								If (@ismbr(&amp;OEP_CurYr) and @ismbr(@LSIBLINGS(&amp;OEP_CurQtr))) 
                    "OFS_Calculated" = @member(@HspNthMbr(@name(@children("YearTotal")), @HspMbrIndex(@name(@children("OEP_Qrtly Plan")), @name(@currmbr(Period)))));                                
            					
                            	else
								%Script(name:="Qrtly_Trends")		
								endif		
							endif			
						    endif			
					elseif (@ismbr(&amp;OEP_YrlyFcstStart:&amp;OEP_YrlyFcstEnd)) 					
							if(Not(@ismbr("No Year")))
                            if (@ismbr("OEP_Yearly Plan")) 			
							%Script(name:="Yearly_Trends")			
							endif			
							endif	

					endif					
					 )					
	 ;									
						
			endfix							
			Fix(OFS_Calculated)							
				calc dim("Account");						
			endfix							
	endfix									
endfix										
endfix

[RevDriver4_EndFix]
[RevDriver3_EndFix]
[RevDriver2_EndFix]
[RevDriver1_EndFix]
[RevSrc2_EndFix]
[RevSrc1_EndFix]

Endfix 			</script></component></statement></else></if></statement><template_wizard><wizard_step name="Inputs" seq="0"/></template_wizard><template_prompts><restricted_prompt name="Application Type" type="Application Type" isPrompt="no"><property name="is_system">true</property><restricted_prompt_item><property name="prompt">Is Generic</property><property name="value">GENERAL</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is PFP</property><property name="value">PROJECT</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is PSB</property><property name="value">PSB</property></restricted_prompt_item></restricted_prompt><restricted_prompt name="Application" type="Application" isPrompt="no"><property name="is_system">true</property><value>Is Single Currency</value><restricted_prompt_item><property name="prompt">Is Multi Currency</property><property name="value">multi</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is Single Currency</property><property name="value">single</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is Simple Currency</property><property name="value">simple</property></restricted_prompt_item></restricted_prompt><template_slice_prompt name="UpperPOV" type="Member Range" isPrompt="false"><property name="is_system">true</property></template_slice_prompt><restricted_prompt name="Essbase Mode" type="Essbase Mode" isPrompt="no"><property name="is_system">true</property><restricted_prompt_item><property name="prompt">Is Hybrid</property><property name="value">Hybrid</property></restricted_prompt_item><restricted_prompt_item><property name="prompt">Is NonHybrid</property><property name="value">NonHybrid</property></restricted_prompt_item></restricted_prompt><template_prompt name="Rev Source Flex1" type="String" isPrompt="false"/><template_prompt name="Rev Source Flex2" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex1" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex2" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex3" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Rev Driver Flex4" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="RevSrc1_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc1_Agg" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Fix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevSrc2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver1_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver2_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver3_Agg" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Fix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_EndFix" type="String" isPrompt="false"/><template_prompt name="RevDriver4_Agg" type="String" isPrompt="false"/><template_prompt name="mPeriod" type="Members" isPrompt="true"><property name="dim_type_limit">Period</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Period</property></template_prompt><template_prompt name="mYear" type="Members" isPrompt="true"><property name="dim_type_limit">Year</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Years</property></template_prompt><template_prompt name="mVersion" type="Member" isPrompt="true"><property name="dim_type_limit">Version</property><property name="dimension_limit">both</property><property name="prompt_text">Enter Version</property></template_prompt><template_prompt name="strEndFix" type="String" isPrompt="false"><value>EndFix</value></template_prompt><template_prompt name="dCurrency" type="Dimension" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property><value>Currency</value><dimension name="Currency"/></template_prompt><template_prompt name="strCurrencyFix" type="String" isPrompt="false"><property name="isMandatory">false</property><property name="isreadOnly">false</property></template_prompt><template_prompt name="Weekly" type="String" isPrompt="false"/><template_prompt name="IsWeeklyEnabled" type="Boolean" isPrompt="false"/><template_prompt name="WKScript" type="String" isPrompt="false"><value>@ismbr(@relative("OEP_Weekly Plan", 0))</value></template_prompt></template_prompts></template></templates></HBRRepo>